﻿CREATE UNIQUE NONCLUSTERED INDEX [RoomUniqueKey]
    ON [dbo].[Room] 
    (
		[EntranceId] ASC,
		[FloorId] ASC,
		[Name] ASC
    )